| |
|
With MySQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"? Question Posted on 23 Sep 2023 Home >> DataBase >> MySQL MCQ >> With MySQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"? |
With MySQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?
Choose the correct option from below list
(1)SELECT * FROM Persons ORDER BY FirstName DESC
(2)SELECT * FROM Persons ORDER FirstName DESC
(3)SELECT * FROM Persons SORT BY 'FirstName' DESC
(4)SELECT * FROM Persons SORT 'FirstName' DESC
Answer:-(1)SELECT * FROM Persons ORDER BY FirstName DESC | |
|
|
|
|